Load Libraries

Function to Load csv


(Preparation - 1 of 3) Import Datasets

Source 1 - Malaria Dataset

Source 2 (Additional) - Country Mapping - ISO, Continent, Region


Load File 1 - ISO-3166 Country Code Information (Additional Dataset)

Load File 2 - Malaria deaths by Age

Load File 3 - Incidence of Malaria (per 1,000 population at risk)

Load File 4 - Malaria Deaths (per 100,000 people)


(Preparation - 2 of 3) Perform Left Merge with df_continents to Introduce More Details Based on Country Code from the Given Datasets.



(Preparation - 3 of 3) Cleaning Up after Merging with df_continents File to Introduce Region Groupings


DataFrame = df_m_inc_joined

DataFrame = df_m_deaths_age_joined


(Overview) Average Malaria Death by Region


Overview Observations

  1. Some of the highest average Malaria Deaths are found in countries in the continent of Africa, as seen by the more intensely coloured and larger sized circles on the map.
  2. Only the countries with average Malaria Deaths from years 1990 to 2016 above the median are shown here.
  3. We will dive deeper to compare the Malaria figures across the world.

(Plot 1 of 3) Average Malaria Death by Region


Observations 1

  1. General Trend
    • Generally, we see that Malaria deaths have been decreasing steadily for all regions from year 1990 onwards.
    • All regions except "Sub-saharan Africa" and "Melanesia", have had relatively low Malaria deaths throughout the time period of years 1990 to 2016.
    • The death toll for the rest of the world is nearly close to zero in comparison with the "Sub-Saharan Africa" and "Melanesia" regions.
  2. Melaria deaths in "Melanesia" rose significantly around year 1998, before falling after year 2004. The level of Malaria deaths eventually fall to levels comapriable to the other regions of the world (except "Sub-Saharan Africa").
  3. "Sub-saharan Africa" is a concern, given that it has consistently the highest Malaria Deaths compared to all the other regions in the world.
    • We should proceed to study further on the "Sub-saharan Africa" region to understand more.

(Plot 2 of 3) Incidence of Malaria by Region - Sub-Saharan Africa


Observations 2

  1. General Trend
    • Generally, the incidence of Malaria have been decreasing steadily over the recent uears from year 2000 to year 2015.
    • Quite clearly, we can see that the incidence of Malaria is significantly lower for "Southern Africa".
  2. "Western Africa" remains consistently the highest incidence of Malaria over the years.
  3. We may want to study how "Southern Africa" is managing the spread of Malaria.
  4. We will continue to explore the dataset on the least controlled region in Sub-Saharan Africa, "Western Africa".

(Plot 3 of 3) Malaria Deaths in the Least Controlled Region in Sub-Saharan Africa


Observations 3

  1. Generally, the average deaths for the Age Group of "Under 5" is significantly much higher than the rest of the Age Groups in "Western Africa".
  2. The death toll for the rest of the Age Groups are nearly close to zero when compared to the Age Group of "Under 5".
    • We should focus more resources on helping the Age Group of "Under 5" in "Western Africa" deal with the treatment of Malaria.